Tabela Episode

Definicja tabeli Episode

Name

Episode

Code

Episode

Comment

 


Lista kolumn tabeli Episode

Name

Code

EpisodeID

EpisodeID

PatientID

PatientID

DischargeModeID

DischargeModeID

AdmissionModeID

AdmissionModeID

ReferralID

ReferralID

HealtProgrammeID

HealthProgrammeID

ContractID

ContractID

MalignantTumourId

MalignantTumourId

ExternalEpisodeID

ExternalEpisodeID

AdmissionDate

AdmissionDate

DischargeDate

DischargeDate

MainBook_childNo

MainBook_childNo

MainBookNo

MainBookNo

MainBookPos

MainBookPos

MainBookYear

MainBookYear

EpisodeType

EpisodeType

causeOfDeath

causeOfDeath

toSend

toSend

Character

Character

HospitalizationMode

HospitalizationMode

Date

Date

AccountVersion

AccountVersion

ModDate

ModDate

Version

Version

toDelete

toDelete

CurrentAccountDataStatusID

CurrentAccountDataStatusID

MainBookFull

MainBookFull

isEmergency

isEmergency

NumberOfMonthSinceFallingIll

NumberOfMonthSinceFallingIll

NumberOfDaysFromDischarge

NumberOfDaysFromDischarge

BarthelADL

BarthelADL

ASIA

ASIA

GMFCS

GMFCS

MainDiagnosis

MainDiagnosis

AdditionalDiagnosis1

AdditionalDiagnosis1

AdditionalDiagnosis2

AdditionalDiagnosis2

AdditionalDiagnosis3

AdditionalDiagnosis3

AdditionalDiagnosis4

AdditionalDiagnosis4

AdditionalDiagnosis5

AdditionalDiagnosis5

NfzVersionNo

NfzVersionNo

NfzAccountVersionNo

NfzAccountVersionNo

NfzLastSwzMessageNo

NfzLastSwzMessageNo

RumCardNumber

RumCardNumber

RumDuplicateNo

RumDuplicateNo

AuthorizationDate

AuthorizationDate

HashCode

HashCode

AdmissionBedsores

AdmissionBedsores

DischargeBedsores

DischargeBedsores

BrainDeath

BrainDeath

BrainDeathDecisionDT

BrainDeathDecisionDT


2